﻿CREATE TABLE [dbo].[WayBillDetail] (
    [Id]                      UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [WayBillId]               UNIQUEIDENTIFIER NOT NULL,
    [IssuedBy]                UNIQUEIDENTIFIER NOT NULL,
    [DriverName]              NVARCHAR (250)   NULL,
    [VehicleRegNo]            NVARCHAR (50)    NULL,
    [TransportCompany]        NVARCHAR (250)   NULL,
    [DriverLicenseNo]         NVARCHAR (50)    NULL,
    [ReceivingLocation]       UNIQUEIDENTIFIER NULL,
    [ReceivedBy]              UNIQUEIDENTIFIER NULL,
    [ArrivalDate]             DATE             NULL,
    [DRCVehicleMileage]       FLOAT            NULL,
    [DRCVehicleTotalDistance] FLOAT            NULL
);

